<?php
    require'isok.php';
    require'database.php'; 
 $sql="select a.*,b.nickname,c.name from posts a, users b, categories c where a.user_id=b.id and a.status!='trashed' and c.id=a.category_id order by id  desc";
   $result=$db->query($sql);
  $num=$result->num_rows;
  $postdata=$result->fetch_all(MYSQL_ASSOC);

   $page= isset($_GET['page'])?$_GET['page']:1;
   $sql='SELECT COUNT(*) AS total FROM posts';
   $res=mysql_query($sql);
   $row=mysql_fetch_assoc($res);
   $total=$row['total'];
   $size=15;
   $length=ceil($total/$size);
   $rows=findByPage($page,$size);
  
?>

<!DOCTYPE html>
<html lang="zh-CN">
<head>
  <meta charset="utf-8">
  <title>阿里百秀登录管理</title>
  <link rel="stylesheet" href="../assets/vendors/bootstrap/css/bootstrap.css">
  <link rel="stylesheet" href="../assets/vendors/font-awesome/css/font-awesome.css">
  <link rel="stylesheet" href="../assets/vendors/nprogress/nprogress.css">
  <link rel="stylesheet" href="../assets/css/admin.css">
  <script src="../assets/vendors/nprogress/nprogress.js"></script>
</head>
<body>
  <script>NProgress.start()</script>

  <div class="main">
    <nav class="navbar">
      <button class="btn btn-default navbar-btn fa fa-bars"></button>
      <ul class="nav navbar-nav navbar-right">
        <li><a href="profile.html"><i class="fa fa-user"></i>个人中心</a></li>
        <li><a href="login.php "><i class="fa fa-sign-out"></i>退出</a></li>
      </ul>
    </nav>
    <div class="container-fluid">
      <div class="page-title">
        <h1>所有文章</h1>
        <a href="post-add.php" class="btn btn-primary btn-xs">写文章</a>
      </div>
      <!-- 有错误信息时展示 -->
      <!-- <div class="alert alert-danger">
        <strong>错误！</strong>发生XXX错误
      </div> -->
      <div class="page-action">
        <!-- show when multiple checked -->
        <a class="btn btn-danger btn-sm" href="javascript:;" style="display: none">批量删除</a>
        <form class="form-inline">
          <select name="" class="form-control input-sm">
            <option value="">所有分类</option>
            <option value="">未分类</option>
          </select>
          <select name="" class="form-control input-sm">
            <option value="">所有状态</option>
            <option value="">草稿</option>
            <option value="">已发布</option>
          </select>
          <button class="btn btn-default btn-sm">筛选</button>
        </form>
        <ul class="pagination pagination-sm pull-right"> 
            
            <?php if ($page>1) { ?>
          <li><a href="?page=<?php echo $page-1; ?>">上一页</a></li>
          <?php } ?>
          <?php for($i=1;$i<=$length;$i++) {  ?>
          <li><a href="?page=<?php echo $i; ?>"><?php echo $i; ?></a></li>
          <?php } ?>
       
          <?php if ($page<$length) { ?>
          <li><a href="?page=<?php echo $page+1; ?>">下一页</a></li>
          <?php } ?>  
      
        </ul>
      </div>
      <table class="table table-striped table-bordered table-hover">
        <thead>
          <tr>
            <th class="text-center" width="40"><input type="checkbox"></th>
            <th>标题</th>
            <th>作者</th>
            <th>分类</th>
            <th class="text-center">发表时间</th>
            <th class="text-center">状态</th>
            <th class="text-center" width="100">操作</th>
          </tr>
        </thead>
        <?php foreach($rows as $key=>$val) { ?>
          <tr>
            <td class="text-center"><input type="checkbox"></td>
            <td><?php echo $val['title']; ?></td>
            <td><?php echo $val['nickname']; ?></td>
            <td><?php echo $val['name']; ?></td>
            <td class="text-center"><?php echo $val['created']; ?></td>
            <?php if($val['status']=='published') { ?>
            <td class="text-center">已发布</td>
            <?php } else {?>
            <td class="text-center">草稿</td>
            <?php } ?>
            <td class="text-center">
                <a href="post-edit.php?id=<?php echo $val['id']; ?>" class="btn btn-default btn-xs">编辑</a>
             <a  href="javascript:" onclick="if(confirm('确定删除吗？')) location.href='postsdel.php?id=<?php echo $val['id']; ?>'" class="btn btn-danger btn-xs">删除</a>
            </td>
          </tr>
          <?php } ?>
         
        </tbody>
      </table>
    </div>
  </div>
<?php include 'aside.php';?>
  <script src="../assets/vendors/jquery/jquery.js"></script>
  <script src="../assets/vendors/bootstrap/js/bootstrap.js"></script>
  <script>NProgress.done()</script>
</body>
</html>
